StockLocateRequestGateway

V8 Message Definiton

Records inserted into this gateway become locate requests and are visible in the StockLocateRequest table.

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	SystemData
Product	SRControl
accessType	SELECT,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
coreClientFirm	VARCHAR(16)	PRI	''
locateFirm	VARCHAR(6)	PRI	''	locate firm defaults to clientFirmConfigdefaultLocateFirm
locatePool	VARCHAR(16)	PRI	''	locate pool firm granting the locate defaults to clientFirmConfigdefaultLocatePool
isLivePool	enum - YesNo	PRI	'None'
requestQuan	INT		0	cumulative request quantity for the trading day
timestamp	DATETIME(6)		'1900-01-01 00:00:00'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
coreClientFirm	4
locateFirm	5
locatePool	6
isLivePool	7

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRControl`.`MsgStockLocateRequestGateway` (
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '',
    `coreClientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `locateFirm` VARCHAR(6) NOT NULL DEFAULT '' COMMENT 'locate firm (defaults to clientFirmConfig.defaultLocateFirm)',
    `locatePool` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'locate pool @ firm granting the locate (defaults to clientFirmConfig.defaultLocatePool)',
    `isLivePool` ENUM('None','Yes','No') NOT NULL DEFAULT 'None',
    `requestQuan` INT NOT NULL DEFAULT 0 COMMENT 'cumulative request quantity for the trading day',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00',
    PRIMARY KEY USING HASH (`ticker_tk`,`ticker_at`,`ticker_ts`,`coreClientFirm`,`locateFirm`,`locatePool`,`isLivePool`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='Records inserted into this gateway become locate requests and are visible in the StockLocateRequest table.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `coreClientFirm`,
    `locateFirm`,
    `locatePool`,
    `isLivePool`,
    `requestQuan`,
    `timestamp`
FROM `SRControl`.`MsgStockLocateRequestGateway`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */
    `coreClientFirm` = 'Example_coreClientFirm'
  AND
    /* Replace with a VARCHAR(6) */
    `locateFirm` = 'Example_locateFirm'
  AND
    /* Replace with a VARCHAR(16) */
    `locatePool` = 'Example_locatePool'
  AND
    /* Replace with a ENUM('None','Yes','No') */ 
    `isLivePool` = 'None';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRControl`.`MsgStockLocateRequestGateway`(
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts`,
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk`,
    /* Replace with a VARCHAR(16) */
    `coreClientFirm`,
    /* Replace with a VARCHAR(6) */
    `locateFirm`,
    /* Replace with a VARCHAR(16) */
    `locatePool`,
    /* Replace with a ENUM('None','Yes','No') */ 
    `isLivePool`,
    /* Replace with a INT */ 
    `requestQuan`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'None',
    'None',
    'Example_ticker_tk',
    'Example_coreClientFirm',
    'Example_locateFirm',
    'Example_locatePool',
    'None',
    5,
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRControl`.`MsgStockLocateRequestGateway` 
WHERE
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */
    `coreClientFirm` = 'Example_coreClientFirm'
  AND
    /* Replace with a VARCHAR(6) */
    `locateFirm` = 'Example_locateFirm'
  AND
    /* Replace with a VARCHAR(16) */
    `locatePool` = 'Example_locatePool'
  AND
    /* Replace with a ENUM('None','Yes','No') */ 
    `isLivePool` = 'None';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='StockLocateRequestGateway' ORDER BY ordinal_position ASC;